In automatic mode, only outdated formula values are recalculated when opening a document. If you want to force calculate all formulas in the document, press Ctrl+Shift+F9 (Windows, Linux) or  Shift+ Cmd+F9 (macOS).